Viewing 15 posts - 1,081 through 1,095 (of 2,904 total)
Aha! quote:The error is raised and the database is left in a LOADING state.
A database left in a loading state is 'usually' waiting for more files to be restored....
May 2, 2006 at 7:44 am
Are the SQL Server editions (7, 2000, 2005) and versions (Service Pack levels) the same on both systems (where the backup came from and where the restore is occuring)?
Are you...
May 1, 2006 at 12:03 pm
The error message was pretty clear. You need to do the backup allowing it do FORMAT the file first.
I suggest you read the BOL for information on doing backups and...
May 1, 2006 at 11:53 am
Where do you get the size of your log file from?
There are two actual sizes of the log file. First, the size of the log's data and second, the...
May 1, 2006 at 11:41 am
Today ComputerWorld is saying the problem is across the U.S., not just your county, not just your state.
-SQLBill
April 13, 2006 at 10:51 am
None. The instances don't have to match. However, you will need a way to keep track of the SP levels for each instance for future upgrades.
-SQLBill
April 13, 2006 at 10:46 am
What do you mean by: "...add to the MSDB from a location"? Do you mean 'restore more information'? If so you can't.
It's late, but you should have scheduled your MSDB...
April 13, 2006 at 10:45 am
Are you talking about SQL Server service packs? If so, you really should be at SP3a or SP4. It probably is a service pack issue. Why don't you try installing...
April 13, 2006 at 10:38 am
Yes, they are answers. You ran SHRINKDATABASE using the WITH TRUNCATE_ONLY option. With Truncate_Only removes inactive portions of the log file. But it does NOT 'return' the empty space to...
April 13, 2006 at 10:35 am
No. Not really. When you run that command the log file is CHECKPOINTed. Only COMMITTED transactions are removed. In other words, the only data you are removing from the tlog...
April 13, 2006 at 6:59 am
To build a server with SP3a and Hotfix 878, you just need to install SP3a and any APPLICABLE hotfixes that came out after SP3a.
-SQLBill
April 13, 2006 at 6:56 am
No, that's not true. Most hotfixes only fix one or two specific faults.
Service Packs are all 'inclusive'.
-SQLBill
April 13, 2006 at 6:55 am
One good site to check out the version number is:
http://www.sqlsecurity.com go to the FAQs/DOCs link and select SQL Server Version Database. Shows every number used and what it...
April 12, 2006 at 11:20 am
Sushila,
You highlighted this line in one of your posts:
on Windows NT 5.0 (Build 2195: Service Pack 4).
I just wanted to point out that is NOT your SQL Server...
April 12, 2006 at 11:17 am
Did you run DBCC UPDATEUSAGE before you reran sp_spaceused?
Look in the BOL for the syntax.
-SQLBill
April 12, 2006 at 11:11 am
Viewing 15 posts - 1,081 through 1,095 (of 2,904 total)