Viewing 15 posts - 736 through 750 (of 1,098 total)
Is this a question about merge replication conflicts?
April 3, 2003 at 5:41 am
No,I don't use it. I only used a maintenance plan for the backup of my system databases, but if you want to limit the size of your table that logs...
April 3, 2003 at 5:33 am
You want to compare table structure or data?
April 3, 2003 at 5:29 am
use QA to restore a db. If you used the last backup file, run restore database dbname with recovery.
You should use the recovery after restoring the last backup file, and...
April 2, 2003 at 12:41 pm
Well you should test the time that it takes to execute a full backup, and maybe you could execute one in the middle of the week, or even at night...
April 2, 2003 at 12:26 pm
The restore verify only won't tell you if the restore process wil work fine. It doesn't check the consistency of the data inside the backup. So I also think the...
April 2, 2003 at 10:57 am
No, the inserts are always logged. Even if you create a table and then insert the records, or let SQL to create the table with a select into, SQL logs...
April 2, 2003 at 10:54 am
That will depend of many things like the expected size of the database, the number of transactiions, etc.
If you think you will have a big db, then you could use...
April 2, 2003 at 10:50 am
You could also create a SQL Login, then change the ownership of all the objects to that sql login, change the domain and logins, and then reconfigure the server for...
April 2, 2003 at 6:21 am
Maybe both predicates found no match. Did you try with OR instead if and?
April 1, 2003 at 1:42 pm
Don't know much about ASP, but if executing a restore sentence directly is a problem I think you could create a stored procedure with the restore sentence that you need...
April 1, 2003 at 1:21 pm
I think that you should let the fill factor high if for example the updates are, for example, from string of 100 char lenght to 100000 char lenght. In cases...
April 1, 2003 at 1:10 pm
If you don't have SP3, cancelling a bcp operation can also generate consistency errors.
April 1, 2003 at 12:54 pm
Viewing 15 posts - 736 through 750 (of 1,098 total)