Original Data And Log Size
How can I find out the original size of the Data and Log files?
TIA
Rob
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
Reduce The File Size Less Then Original Size In SQL 2000
I have one db test with one .mdf and .ldf file...mdf file size is 100mb and for some reson i removed all the tablesfrom that .mdf file and transfer it into new secondary file so all thetables moved into secondary file now i want to reduce the first .mdffile from 100 mb to 50mb is that possible,it's showing 90mb is free.Please reply
View Replies !
View Related
Shrink Tempdb Below Original Size.
I have a tempdb that was created at 1Gig. I don't know why but I want to shrink it below the original creation size. Is there a way to shrink this file or create a new file and delete the old? I have tried shinkfile and shrink database with no luck. Thanks Jeff
View Replies !
View Related
How Do You Deal With Page Refresh After A Filter Has Been Applied To Original Data?
I have added a page refresh in combination with 'Command Notification' to ensure that my data is fresh,( it is updated on the sql server database approx. every 5 mins). However, I also allow filtering on the table contents and every time I refresh the filtering is lost. Is it possible to maintain the filtering through the refresh? <meta http-equiv="refresh" content="30"/>..<asp:SqlDataSource ID="SqlDataSource1" runat="server" ..SelectCommand="SELECT ... EnableCaching="true" CacheDuration="Infinite" CacheExpirationPolicy="Absolute" SqlCacheDependency="CommandNotification" >
View Replies !
View Related
How To Select Data From Excel Table By Original Column Order?
Hello, everyone: I have an Excel table that has columns like, Vendoe_Name Level Address Email Phone I use the statemen SELECT * FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0', 'Data Source=C: est.xls;Extended Properties=Excel 8.0')...[Sheet1$] and got output by column order, Address Email Level Phone Vendoe_Name How to make output by original column order like, Vendoe_Name Level Address Email Phone Any help will appreciated. Thanks ZYT
View Replies !
View Related
SQL2005 Data Import Error, Unicode Data Is Odd Byte Size For Column &&<n&&>. Should Be Even Byte Size
Hi, I have a problem importing data from SQL Server 2000 'text' columns to SQL Server 2005 nvarchar(max) columns. I get the following error when encountering a transfer of any column that matches the above. The error is copied below, Any help on this greatly appreciated... ERROR : errorCode=-1071636471 description=An OLE DB error has occurred. Error code: 0x80004005.An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Unicode data is odd byte size for column 3. Should be even byte size.". helpFile=dtsmsg.rll helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC} (Microsoft.SqlServer.DtsTransferProvider) Many thanks
View Replies !
View Related
Best Practice For Data Size/Log Size Ratio
Just wanted to know what is a general rule of thumb when determining log file space against a database's data file.We allow our data file for our database to grow 10%, unlimited. We do not allow our log file to autogrow due to a specific and poorly written process (which we are in a three month process of remove) that can balloon the log file size.Should it be 10% of the Data file, i.e. if the Date file size is 800MB the log file should be 8MB?I realize there are a myraid of factors that go against file size but a general starting point would be nice.ThanksJeff--Message posted via http://www.sqlmonster.com
View Replies !
View Related
Estimating Data Size And Log Size In A Database
Question 1: I wonder if anyone could help me on estimating the acutal data size and its log size for MS-SQL Server version 7. I know that on-line book specifies the procedure of the data size but I have some data items with attribute of data type as "Text". In order to include the data type "Text" how many bytes of overhead and fill factor to be considered for data size calculations? Question 2: Also, I want to know that if anyone can help me with log size calculation for a table. It's just not good enough if the on-line book says to take from 25 to 50 % or something....it is too vague and I can not take the answer. Here are the example of the table and if anyone can include the answers to the questions above. It will be great. (Example:) Can anyone help me to figure out the data and log size respectively based on the conditions below: ---------------------------------------------- 1. Table Name: A_TBL 2. Table Format: Item Data Type Length -------------------------------------------------------- EmployeeNumber Char 20 EmployeeName Char 50 EmployeeURL TEXT 16 -----pointing---> 256 EmployeeMemo TEXT 16 -----pointing--->1000 EmployeeTitleNo Int 4 3. DB(Table) access frequency per transaction: Insert = 1 time/transaction Update= 2 times/tranaction Select = 6 times/tranaction 4. Transaction occurred: 10 times, therefore; 10 INSERT, 20 UPDATE, 60 SELECT statements are issued. (I guess 60 SELECT statements are not subject to be in the log so forget the SELECT statement) 5. Fill Factor 100 for all the data type. 6. Non-Clustered index is set for the above. I really want to know about it, please help me on this. Regards,
View Replies !
View Related
Weekly Update Part Of Database With Data From Original Database
Hi! I have an original database that I want to copy once to another database. Then I want to update the data weekly with the data of the original database. I don€™t change any tables or columns in that part of the database. Just some tables more in the €˜new€™ database (than the tables from the original database) with some references to the tables that have to be updated weekly. How can I do this? (if you know what I mean... it's a sort of a datawarehouse where different sources come together.. that part that represents the original database is just a part of the datawarehouse. That part is exactly the same structure as the original database.) Thanks, Sandra
View Replies !
View Related
ORIGINAL SIN IN SQL 2005!
from the December 2004 _Redmond Magazine_, "Finding Gold in Yukon":http://redmondmag.com/columns/artic...ditorialsID=838"Developers will also pick up the usual new-version enhancements to T-SQL,including error handling, recursive queries, a ROW_NUMBER function, a PIVOTrelational operator and more."ROW_NUMBER???? What possible purpose could that have???
View Replies !
View Related
Decrypted Value Is Different From The Original One
Hi, I got an issue with encrypt and decrypt. I encrypted a data, say 'ok', then I decrypt the encrypted data, but what I got is not 'ok'. but if I encrypt a column, then after decryption, those data asr same with the original data in that column. In my case, ... create table mytable ( column Password varbinay(128) ) ... create symmetric key with certificate ... OPEN SYMMETRIC KEY Sym_Key_01 DECRYPTION BY CERTIFICATE Cert; UPDATE mytable SET Password = EncryptByKey(Key_GUID('Password_01'),'ok') select CONVERT(nvarchar, DecryptByKey(Password)) AS "Decrypted Password" from mytable here, I didn't get the value 'ok' but a another wierd word (like a chinese word). does someone know the reason? Thanks, Jone
View Replies !
View Related
@original And Stored Procedures
When using @original_{0}, how does this work if you are using a stored procedure instead of inline SQL? For example, if my update parameters are like this : <UpdateParameters> <asp:Parameter Type="String" Name="ProductType" /> <asp:Parameter Type="String" Name="OpportunityType" /> <asp:Parameter Type="Double" Name="Value" /> <asp:Parameter Type="String" Name="Probability" /> <asp:Parameter Type="Int32" Name="OpportunityID" /> </UpdateParameters> And my stored procedure like this : CREATE procedure dbo.UpdateOpportunity ( @ProductType int, @OpportunityType int, @Value money, @Probability int, @OpportunityID int) as update Opportunity set ProductType = @ProductType, OpportunityType = @OpportunityType,[Value] = @Value, Probability = @Probabilitywhere OpportunityID = @OpportunityID Do I need to change both cases of @OpportunityID in my stored procedure to @original_OpportunityID for it to work?
View Replies !
View Related
Fuzzy Grouping Using Original Key
I managed to get fuzzy grouping working. The relevant output (_key_in and _key_out) are stored in a new table that is a copy of the old table + fuzzy grouping columns. How do i get SSIS to store the _key_in and _key_out in the original table? The new matching column _key_out refers to the new key: _key_in. How could i get SSIS translate that to a matching column that refers to my original key?
View Replies !
View Related
Different Results Same Query Between Original And Copied Db
Hi all, I restored a backup of a database running SQL Server in W2K to my own laptop (Windows XP) for report testing pourposes. The restore worked perfectly, but when I ran the store procedure that returns my "report" set I noticed that several of the fields within the result set are different, the number of rows and customers are a perfect match to the production report. The fields that are different are calculated fields that invoque a user defined function, which again are exactly the same on both databases. I tried dropping the stored procedure and the 4 functions and recreating them again but I get the same results, the number of rows, the customers and all "non" function calculated fields are perfect, only the fields calculated with the functions are wrong. Has anybody seen this behavior? Thanks for your help Luis Torres
View Replies !
View Related
Get Original Login Name After Context Switch
Does anyone know how to get the original Login name, while a context switch is in effect.. For example during the use of Original login to SQL is Wayne Then Execute as Test Now I need to know that Wayne is the Login and not Test none of the standard things work, they all use the current context (suser_sname, etc)... Books online includes the following text SYSTEM_USER returns the name of the currently executing context. If the EXECUTE AS statement has been used to switch context, SYSTEM_USER will return the name of the impersonated context. Use the LOGIN() function to return the name of the original login during impersonation. But I cannot find any function called LOGIN() anywhere? Suggestions>?
View Replies !
View Related
Changes To Cloned Database Are Affecting The Original
I am trying to use SQL Express to support unit testing of functionality which requires database access. I created an express database (.mdf) which contains a database snapshot which is the database environment that each test expects to see when it starts. Through the execution of the test the database will be modified arbitrarily and I need to reset the database to the original state before the next test executes. Here's what I do today: Before Test: The original database is copied to a unique location in the temp directory A unique database name is generated (GUID-based) I connect to the new database file with: Server=.SQLEXPRESS;AttachDbFilename="PathToTempFile";Database="GuidDBName";Initial Catalog="GuidDBName";Trusted_Connection=Yes;User Instance=true During the test all database access is routed to the temporary database GuidDBName After Test: Close all active database connections and clear the connection pool Connect to the master database and detach the database: Server=.SQLEXPRESS;Database=master;Initial Catalog=master;Trusted_Connection=Yes;User Instance=true - sp_detach_db 'GuidDBName' Delete the temporary file When I do this, everything seems to work correctly but when I re-open the original database it has changed unexpectedly and includes the modifications that were made by the test as it ran. Can anyone explain why this is happening and/or provide a solution?
View Replies !
View Related
Data Used Bigger Than Data Size
One of our databases has the following sizes: Data used : 4017.14MB (191.29%) Indexes 35.48 mb (1.69%) Unused : 5.27 MB (0.25 %) Unreserved: -1957.89 mb (- 93.23 %) Total Size 2100MB looking at this the data size is 2100Mb and the data used is more at 4014.14MB. How can I sort this out, do I simply need to create another device and expand the database or do I need to do something else? Cheers
View Replies !
View Related
Data Used Bigger Than Data Size
One of our databases has the following sizes: Data used : 4017.14MB (191.29%) Indexes 35.48 mb (1.69%) Unused : 5.27 MB (0.25 %) Unreserved: -1957.89 mb (- 93.23 %) Total Size 2100MB looking at this the data size is 2100Mb and the data used is more at 4014.14MB. How can I sort this out, do I simply need to create another device and expand the database or do I need to do something else? Cheers
View Replies !
View Related
Sql Data Size Max
hi in sql server i set the datastype en size of the column messagetext to nvarchar and max but how do i set max in the code below cause i only can set an int in the place where the datasize has to be objCmd.Parameters.Add("@MessageText", SqlDbType.NVarChar, 50).Value = txtbericht.Text tnx
View Replies !
View Related
How To Getback Original Copy Of Northwind Database?
Hi,Good morning to All. While doing practice I did some modifications to some tables in Northwind database.Now, how can I get my original tables back again? Take Oracle for example:We can modify table data. But when we run demobld.sql script then all tables will replaces with original entries. Like this I want in SQL Server also. Is there any such facility available in SQL Server? Thanks in advance,Ashok kumar.
View Replies !
View Related
How Can I Use SELECT DISTINCT And Maintain The Original Order
Say I have a result set with two fields numbers and letters. 1 A3 A1 B2 B The result set is ordered by the letters column. How can I select the distinct numbers from the result set but maintain the current order? When I tryselect distinct Number from MyResultSet it will reorder the new result set by the Number field and return 123 However, I'd like maintain the Letter order and return 132
View Replies !
View Related
Copied Database Maintains Original Name In Backups
I made a copy of a database "sac_prod" and named the new copy "vgs_prod". Now, when I do a backup of the new database, it still shows the name of the original. Is there any way to change this so it will be the same as the new database name?Here is the BACKUP script:BACKUPdatabase vgs_prod TODISK='\sac-srvr1data$TechnicalSharedProductionSQLBackup LasVegasvgs_prod_CopyOnly.BAK' with COPY_ONLYHere is the messages I received from this BACKUP:Processed 1752 pages for database 'vgs_prod', file 'sac_prod' on file 1.Processed 6 pages for database 'vgs_prod', file 'sac_prod_log' on file 1.BACKUP DATABASE successfully processed 1758 pages in 0.412 seconds (34.955 MB/sec). I would like to change the file 'sac_prod' to be 'vgs_prod' in lines 1 and 2 just above. Thanks,
View Replies !
View Related
Slowly Changing Dimension Transform And SCD Original ID
I have as simple IS package with a Flat File input and SCD Transform. The package is being used to load a Dimension Table, obviously. The Table was designed in Analyical Services using the Dimension Wizard which very nicely adds End Date, Start Date, Status and Original ID to the Dimension Table design. I then Generate Relational Scheme... and Viola there is a Dim Table in my data warehouse database! I next attempt to use the IS package with SCD Transform to load said Dim Table. The SCD Transform Wizard does a nice job of using the End and Start dates and Status fields in my new Dim Table, but I can not find any way to use the Original ID field? I guess I was expecting that since the SCD Transform Wizard 'knows' how to use all the other fields in this Dim table why not the Original ID field? I know what the Original ID field is for - that's not the issue. I just can not figure out how to 'make' my new IS Data Flow with said SCD Transform use the Original ID field ? Anyone ?
View Replies !
View Related
Back Button Does Not Regenerate Original Report
When I drill down from one report to another and then depress the back button to return to the initial report, the message 'Generating Report" spins forever without actually running. However, if I depress the regenerate button during this time, it will run the report. I believe that I may have inadvertingly reset a field attribute to have caused this condition. Ironocally, I have the same set of database installed on another server, and the this does not happen. I forgot to mention that I am using Report Manager to deploy the reports. Please assist.
View Replies !
View Related
Back Button Does Not Regenerate Original Report
When I drill down from one report to another and then depress the back button to return to the initial report, the message 'Generating Report" spins forever without actually running. However, if I depress the regenerate button during this time, it will run the report. I believe that I may have inadvertingly reset a field attribute to have caused this condition. Ironocally, I have the same set of database installed on another server, and the this does not happen. I forgot to mention that I am using Report Manager to deploy the reports. Please assist.
View Replies !
View Related
Log Shipping.. Original Primary In 'restoring' State
I have a database called PrimaryJunk that is being log shipped to another location, secondary database is secondaryjunk. From PrimaryJunk to SecondaryJunk logs ship and apply fine with no issues. So I figured lets make sure that I am able to perform a role change and swap the roles and that is not working well. My original primary db is stuck in restoring state. I manually backed up the active transaction log on primary server by performing a transaction log backup with the option 'backup the tail of the log and leave the db in restoring state' MS site has the same step but mentions NORECOVERY. I am not sure if my step above does that automatically. http://msdn2.microsoft.com/en-us/library/ms191233.aspx Wonder if thats the reason my original primary db is still in restoring state. any idea?
View Replies !
View Related
SqlDataSource Returns Fewer Results Than Original Sql Query
I have a query that I created in SqlServer and then merely copied the code to a sqldatasource. They are both connected to the same db, however the sqldatasource query only returns 6 records and when run in SqlServer, it returns 52 rows which is the correct number. Any ideas on what might be causing this? There are no filters on the sqldatasource. It only has that one query. Do they differ in the way they execute sql code? Thanks for any help!
View Replies !
View Related
Linked Reports Lose Original Layout For Printing
I have several reports that are set to landscape but then lose this layout when a linked report is created from the original report. I found the link below describing Brian Welcker's workaround and my question is where do you place the vb.net code he provided? http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=137986&SiteID=1
View Replies !
View Related
Compact Edition Creates Too Many DB's And Doesn't Save To The Original
So i am trying to make a simple database and with one table and use a gui to make rows. When i run the program in debug mode it creates a new copy of my DB in the debug folder and saves only their, i cannot find a way to save back to the original DB no matter what i do including changing the Copy to Output Directory. Now the more i try to fix this the more new DB it creates one in the Release Folder, one in the bin/Debug/bin/Debug one in bin/Release/bin/Release. I am going crazy trying to scoure the entire project looking for someplace i can fix this. All i want is to create a DB and be able to make changes to it and only it. Does anyone have any solutions to this? Thank you for your time
View Replies !
View Related
Saving Original SQL Database And My.Settings When Reinstalling Or Updating
Hello all... I am working on a project that contains several databases in SQL and many settings. The problem I am encountering is that I want to be able to update the program for all my customers. That is no problem. The problem I am meeting is where, when the program is updated, all the settings and all the information in the databases reverts to the default values, or the values that were compiled with the new update. I want to be able to update their program without deleting all the settings they have. Thanks, Andreas Renberg
View Replies !
View Related
Data File Size
SELECT size_in_mb,used_size_in_mb,size_in_mb-used_size_in_mb as free_in_mb FROM ( SELECT cntr_value/1024 size_in_mb , (SELECT cntr_value/1024 FROM master..sysperfinfo WHERE counter_name='Log File(s) Used Size (KB)' AND instance_name='mydb') used_size_in_mb FROM master..sysperfinfO WHERE counter_name='Log File(s) Size (KB)' AND INSTANCE_NAME='mydb' ) a I need to store totalsize,usedsize,freesize of the datafiles in a table to get an average of how much my datafile has increased over a week. The above query i am using is for logfile size. Can any one help me with datafile size plz. I've checked sp_helpfile, sysfiles but couldn't find what i am lookin for(used and free space). EM in taskpad view for a database shows the statistics for the datafile. I've tried a trace to find out a stored procedure but couldn't!!! May be i am unaware of a simple stored-procedure that can do this for me. Howdy!
View Replies !
View Related
Different Size Of Data Files~~
hi just wondering if any expert out there can answer my question. i got a database separate into 3 datafiles in 3 different drives. i will name it A, B, C. A datafile size 30G, B datafile size 15G, C datafile size 15G. and the drive for datafile A is about full. so is there anyway i can more some of data from A datafile to other data file? or since A+B+C =60G can i make it all 20G for each one of them by any command? thanks!!! :)
View Replies !
View Related
Custom Events While Retaining Original Event Arguments (SqlDataSourceStatusEventArgs)
Hi, I am looking to implement a custom event handler that will also retain the original event arguments (in addition to several custom arguments). Specifically, I am looking to pass custom arguments into a SqlDataSourceStatusEventHandler, but also want to be able to access the Command.Parameters. I have implemented a new Event Arguments class (derived from System.EventArgs), new Event class and delegate, but do not know how to retain the SqlDataSourceEventArgs. I would really appreciate your suggestions! Thanks!
View Replies !
View Related
Does Isolation Level Revert Back To Ts Original Value In Case Of An Error?
In following code, will isolation level revert back to original value if error occurs before transaction completes ? (original means the default isolation level used by SQL Server 2000) SET TRANSACTION ISOLATION LEVEL REPEATABLE READbegin tran update table1 set column1 = 100 if @ERROR = 0 begin declare @stat int set @stat = (select stat from table2 where employeeid = 10) insert into table3 (col1, col2) values (@stat , 325) if @@ERROR = 0 commit tran else rollback tran end else roll back tran
View Replies !
View Related
SSIS Packages With Different Destination Databases... Removing Original DB Reference
Hi All, OK, so I have an SSIS package that I build using the "test" database as the destination. Now I want to execute it using another database as the destination. This is basically for an installation script where the source is always the same, an access database. So here I have: "C:Program Files (x86)Microsoft SQL Server90DTSBinnDTExec.exe" /file e:data_import.dtsx /CONNECTION DestinationConnectionOLEDB;""Data Source=(local);Initial Catalog=Test2DB;Provider=SQLNCLI.1;Integrated Security=SSPI;Auto Translate=False;"" Which works (sort of). It does try to import the data into "Test2DB", but what happens is all of the destination tables in the dtsx package have names like [test1db].[dbo].[tablename] So my question is: is there a way to remove the databasename reference in the table names for all 195 tables in my database without doing it manually? Thanks in advance.
View Replies !
View Related
Data File Size Problem
how can i change the initial size of the data and log file size ??? in my database properties it shows that my data file size is 81 mb and log file size is 985 mb! but my database only contains some tables and stored procedures with few rows of data in each tableand i checked that the actual mdf and ldf files are really that big... i tried to change it but it didn't work...can someone please teach me how to change it thanks!
View Replies !
View Related
The Size Of The Image Data Type
I'm using ODBC to interface a Microsoft SQL Server 2000. One of theoperations involves placing files within BLOBs. I'm using the imagedata type for this purpose. Most of the time this works okey, but whentrying to add a 21,3 MB file I get an error. The error code is 22001,which means "String right-truncation". But why? Does this mean thatthe field cannot accepts BLOBs with this size?
View Replies !
View Related
|
TRACKER
