Viewing 15 posts - 181 through 195 (of 307 total)
MY suggestion = Go to microsoft.com and down load a trial copy of SQL Server. . Read the install guide and go through setting up your own database. Make sure...
March 24, 2003 at 1:59 pm
The question really is, can you restore a backup from SQL 7 to 2K ? That's all log shipping does - no magic.
John Zacharkan
March 24, 2003 at 1:42 pm
The production server does nothing other than generate transaction backups. Drop your transaction logs on the production server.
SQLServerAgent on the stand by server should be started with an...
March 24, 2003 at 11:50 am
All paths are the same. Agree on patching up before replacing the master.
Thanks Steve.
quote:
are all the paths the same? I...
March 24, 2003 at 7:07 am
If you are using ARC with the SQL Server hook/add on installed then you shouldn't be backing up the .ldf directly.
Your only other choice to backup up the...
March 20, 2003 at 1:58 pm
It'll work over a 56K line as long as the connection is available at the time of replication.
quote:
But I would like...
March 20, 2003 at 12:14 pm
Sounds like you're using offline TSM or ARC Server backups. When the backup software is setup it looks at dir/sub dir and files that you want to backup.
The file...
March 20, 2003 at 12:10 pm
Hey anybody who can do the time warp can admin SQL Server, why do you think those Oracle people get so hot under the collar.
March 13, 2003 at 9:33 am
Ok here are the steps that corrected my problem
1. Disable IISAdmin, INTEL NMS, and TSMSched.
2. Driver signing is a new feature for Win2K....
March 12, 2003 at 3:02 pm
Try
DBcc showcontig (30)
quote:
I think the problem is in here:Logical Scan Fragmentation ..................: 0.00%
Never saw a % so low. I guess it...
March 12, 2003 at 1:41 pm
Let me take a stab at this, I'm not a SQL 2K guy yet. Full recovery mode simply means that every single transaction on the database is recorded and the...
March 12, 2003 at 1:24 pm
If you're trying to do this from QA, make sure you're not sitting in the database that you want to rename. That's alway good for a laugh make sure that...
March 12, 2003 at 9:10 am
It would depend on what that table would be used for. If it's a pure look up table it looks great. It's a heavy transactional table you sequentialy add transaction...
March 12, 2003 at 8:29 am
Thanks for replying Bill,
I have tried it several time on two different boxes, stage and prod, I have also tried using two different copies of the install software, the...
March 12, 2003 at 8:09 am
Viewing 15 posts - 181 through 195 (of 307 total)