Viewing 15 posts - 1,021 through 1,035 (of 1,366 total)
Hi Gail,
How can we make a database in standby mode if we are specifying the WITH NORECOVERY option?
Can you please let me know how to restore the database in...
January 6, 2010 at 8:59 pm
Try This
use tempdb
go
DBCC shrinkfile(tempdev,truncateonly)
Restarting the server will recreate the tempdb 😀
January 6, 2010 at 12:56 am
Use with move option and also check youar specifying the correct files.
December 17, 2009 at 5:22 am
think you cant backup to multiple devices at a time.
You can take backup to multiple locations or drives in a device.
backup database db_name to disk=''path1,
...
December 17, 2009 at 5:16 am
I checked SQL Native Client configuration under SQL Server Configuration Manager and found that all the protocols are missing and if i right clicked and selected properties and getting...
December 17, 2009 at 5:07 am
SQL Server is up and running ..
No issues with connections
December 17, 2009 at 12:11 am
Bru Medishetty (12/15/2009)
Have you tried retrieving the error logs from the \LOG directory using a text exitor?What does it shows in the current error log?
2009-12-15 19:27:19 - ! [298] SQLServer...
December 15, 2009 at 10:33 pm
Jack Corbett (12/15/2009)
What account is the SQL Server Agent running under?
I doubt I'll have the answer, but these are some things I'd...
December 15, 2009 at 10:30 pm
Jack Corbett (12/15/2009)
What account is the SQL Server Agent running under?
I doubt I'll have the answer, but these are some things I'd...
December 15, 2009 at 10:21 pm
HI repent_kog_is_near,
Hope you are using SERVICE PACK 3.
check using select serverproperty('productlevel')
October 21, 2009 at 4:50 am
That was great Bitbucket 😀
October 12, 2009 at 1:22 am
Hi ,
Books online is your friend in this matter. Even if you have huge database you cannot replicate the real time environment. There are lot to learn other than...
October 9, 2009 at 3:04 am
Hi Siva,
You cannot run SQL server if master is corrupted . You need to run SQL Server in the single-user mode and then you can restore the master database.
You will...
October 9, 2009 at 2:57 am
MANU-296622 (9/30/2009)
What do you mean by restore resource database when instance is stopped?MJ
Restoring resource database is just copying the resource database .mdf and .ldf files to location where the master...
October 1, 2009 at 3:13 am
ruchika thapa (9/30/2009)
Copy system databases from another instance to the exact location where the instance expects to find them
-------------------------------------------------------------
what do you mean by this? How to do this?
In...
October 1, 2009 at 2:58 am
Viewing 15 posts - 1,021 through 1,035 (of 1,366 total)