Viewing 15 posts - 1 through 15 (of 64 total)
each option has its own pros and cons and has to be implemented based on evaluation of what are the needs of the architecture .... if you could post what...
March 4, 2010 at 11:24 am
copying to another table would require another 135 GB on the disk ..... do we have that much space ...
you could try a BCP with queryout to output to a...
February 8, 2010 at 12:27 pm
also you could try this
RESTORE VERIFYONLY FROM backup_device WITH LOADHISTORY populates the columns of the backupmediaset table with the appropriate values from the media-set header.
February 8, 2010 at 11:57 am
check the backupset table in msdb on the source of the backup server, it would have the type of backup and the file name
February 8, 2010 at 11:56 am
run SQL upgrade advisor (http://www.microsoft.com/downloads/details.aspx?FamilyID=1470e86b-7e05-4322-a677-95ab44f12d75&displaylang=en)
on a test server (restore backup from production) and go with the recommendations
February 8, 2010 at 11:49 am
you could try adding a step to you r backup job to compress it with winzip and protect it with password .... just a thought
January 14, 2010 at 8:35 am
the distribution agent runs as an OS process ... check the running processes in task manager ..... and I believe there is an upper limit to amount of such processes...
November 10, 2009 at 11:37 am
sp_helplogins 'your loginame' would give you the default database name along with other info ...... If you are just looking for login name and default database .... you could...
November 10, 2009 at 11:29 am
i think you could do an Active-Active cluster ... where both instances of SQL Server are Active and each runs on its different node of the the cluster. Shared Drive...
September 23, 2009 at 9:01 am
nice explanation steve ....
Yes, you can back up transaction log after your reindex operation. To keep log file size in check during the reindex process, i generally increase the frequency...
September 15, 2009 at 12:29 pm
On one of the larger dbs (around 150 GB), I had the need to do reindexing/defrag and update stats on a daily basis. I used Michelle's script[/url] (one of the...
September 15, 2009 at 12:13 pm
since the name TNS appeared I was suspicious about Oracle getting involved. Googled it and found many links for this. Most likely cause could be messed up entries in your...
September 15, 2009 at 11:57 am
george sibbald (9/9/2009)
I don't install BOL on production servers. People should not be using production server resources to lookup help.
dont get me wrong ... but i am trying to figure...
September 9, 2009 at 9:43 am
Viewing 15 posts - 1 through 15 (of 64 total)