sorry it is not possible to do partial restores in that way from one database to another.

You need to look into doing a logical copy of the database to the...

emptyfile just empties the file. To actually stop using it you need to use alter...

SQL fills files in a filegroup on a proportional fill basis. depending on how much free space is available. So it will start to spread data between the files without...

the most resilient way to monitor log shipping is to use a separate instance on its own server to do the monitoring. This can be any edition but the...

thats an important point in this case as you are backing up across the network, be aware...

the situation you describe does not ring true. Are you sure that

a) the user is not a member of some other user defined role that has select permissions on the...

At the risk of over simplifying this (I live by the KISS principle)

set backups up via maintenance plan and place backups for each database in separate sub directories of the...

then you need...

best re-read all the posts, file wont shrink unless its cleared out first. what does dbcc sqlperf(logspace) say for this db.?

shrink the log to a sensible size rather than based...

most probable cause of this is the database is in full or bulk logged recovery mode and the log has never been backed up (or not for a long time)....

thank you Gail.

we will have an incident review next week 🙂

thanks for the feedback, had a feeling it would not be just me. It was happening for me from home and work. Now I seem to be able to get...

kishore, thanks for replying.

excuse me posting this here, but this currently appears to be my only route into SSC.I am getting routed to another page saying 'zoneEdit DNs services for...

you qoute the values in sysaltfiles but this is posted in 2005 forum, is it 2005? If it is check values held in sys.master_files as well.

Hopefully you have a recent...

I am not sure it will be...