Thanks for your thoughts! The intent of the question was not to challenge you SQL Gurus, it was a "trick" question in fact to gain more thoughts from you all.

Generally the snapshots with this time period get expired and the next snapshot generated would be taken for synchronization.

If you are using a Transactional replication u can get rid of...

You dont really need to change this as "Not for Replication" ensures that there is no new ID created and instead allows replication pass the ID value from publisher to...

Hi,

Rashid, How many people are using the Database,If many are using it you need to recheck the Transaction Locking behaviour of your transactions

Cheers,

Raghu Pyapili

Hi Andrew,

If renaming the database is your only concern then, u can try this query,

sp_renamedb 'Olddbname','Newdbname'

Cheers,

Raghu Pyapili

Good Article,However would like to see more articles coming with focus on DBA aspects!

Cheers,

Raghu Pyapili

Hi Rashid,

Did you include any isloation level for your database that ur trying to take the backup?

Cheers,

Raghu Pyapili

Hi Hema,

To start with Both of the Techniques are used for maintaining High Availability, However there are certain differences in their configuration and setup.

Log shipping can be...

Hi,

Peter, I can help you with the syntax.'Test' is my database and use the STATS option while backing up

backup database test

to disk = N'd:\test\testbackup.bak'

with NAME= N'testbackup.bak',stats=10

The Result would be something...

Hi,

Steve is absolutely right, Replication works on Acquire,Manipulate and Write system.

The Snapshot agent reads all the articles of the publication and writes it to Snapshot Files which are stored in...

Hi,

Nali, First make sure that the path supplied is good, then look out for another location.

Does it have any Error number?