Refer the following link:

http://support.microsoft.com/kb/224071/

Hello,

If your environment is Production & 24x 7; You can think about Indexdefrag instead of reindexing. Also if you are using the SQL Server 2005 Ent you can do the...

In Services.msc if SQL Server agent is stuck and shows the status restarting since long...

You need to stop it from command prompt:

net stop "SQL Server Agent(MSSQLSERVER)"

Once stoped; start it:

net start...

You can use robocopy in .bat file

Option is 1 is very prectical and unless you do have VLDB as mention by Jonathan it's perfect solution.

If your DB is very critical and would like to minimise the...

I mean you can restore database in Development SQL Server 2000 and detach it from there and attach to new server SQL 2005.

I know this route is longer but...

If restore is not working do detach and attach database.

If possible, frist of all run DBCC CHECKDB to make sure there are no error into the database.

Take Backup as you have mention.

Perform the Shrink in small chunk i.e. 500...

As mention by GilaMonster exe following T-sql

select * from sys.master_files

search the specific file.

Execute the above query on all the available instances.

You need to check whethere same file is used by other instance or databases.

Execute following command e.g. pubs database

sp_helpdb pubs

It will show all the details of the file used by the specific database.

From your description I understand that your logshipping is working fine. And you can't access the database.

Now there are two scenario one is you can keep your secondary database in...

Thank you, happycat59 for Clarification 🙂

Ajay,

You can scroll all the way down in the 'Post Reply' window; below post Options > Messgae Icons there is "Attachments" you can click Edit Attachments.

Cheers!!!

Hello Paresh,

Nice try to understand the SQL Backup.

Just think one step ahead of and try to understand the internal mechanism...

When full backup is running it is taking the snapshot of...