Viewing 15 posts - 286 through 300 (of 341 total)
You would most likely need to perform the restore of the full backup using the third party tool (if you are using features not found in the standard SQL Server backup), and...
September 23, 2004 at 10:59 am
SQL Server 2005 will be able to do this, writing up to 4 devices. For SQL2K, our product, MiniSQLBackup, has 2 options for this:
September 23, 2004 at 10:56 am
I have never used the MEDIANAME option, and do not know the effects of doing so. Why do you need to use the MEDIANAME option if you are backing up...
September 23, 2004 at 8:21 am
Assuming you are talking about running DBCC DBREINDEX on the clustered index, I recall from a document by Quest Software that SQL Server needs approximately 1.25 times the data space of...
September 22, 2004 at 9:33 am
1. You could give our product, MiniSQLBackup, a try. It can generate smaller backups for you.
2. If you set to overwrite, that means you will only have the latest backup. If you...
September 22, 2004 at 9:22 am
My guess is that server B does not have adequate rights to the other servers' folders. Check your SQL Server startup service account. It cannot be a LocalSystem account if...
September 21, 2004 at 7:12 pm
He probably meant DBCC DBREINDEX.
September 21, 2004 at 10:12 am
There's a possibility that the job may have been started remotely by someone with backup rights. The next time the job runs, you could try running sp_who2 to see where...
September 21, 2004 at 10:07 am
The suggestion provided by sa24 should work.
September 21, 2004 at 12:15 am
SQL is writing a portion of the DB to all 3 devices. Thus, you need all 3 files when you perform the restore.
SQL 2005 will support mirrored backups. If you...
September 20, 2004 at 10:00 am
There isn't any additional space requirements, other than that to contain your database.
Is there a possibility that the data folders on both servers are different? If you restore a database...
September 13, 2004 at 8:01 pm
>> A non-clustered index holds pointers to the data int he leaves of the index.
And to clarify a little more, if a table does not have a clustered index, this...
September 10, 2004 at 3:08 am
Strange question to be posted in the Backups group ....
Anyway, a primary key is a primary key (unique). A clustered index means the physical order of the data is sorted...
September 10, 2004 at 1:12 am
Viewing 15 posts - 286 through 300 (of 341 total)