Viewing 15 posts - 316 through 330 (of 346 total)
Just a though, if you can't increase the size, have you try to re-name the table and recreate the same name table with that size and then import the data...
October 24, 2003 at 10:38 am
I think backup/restore is the easiest because you still have your old database in the old place just in case you need to look at the old stuff again. ...
October 24, 2003 at 10:35 am
yes you can. There are also tools that you can use to do this. It depends if you have them available at your site.
mom
October 23, 2003 at 11:56 am
vavadie,
How did you take your approach? I want to learn from you too.
I was grumbling yesterday...so my response was a bit not too well. Brian was right though....
October 23, 2003 at 11:55 am
vavadie,
If you really do have no say, then say nothing. At the same time don't give any more permission then what they already have. Just told them that...
October 22, 2003 at 8:43 am
I just though, if you were to extract data for a test database why don't you just create a test database on your server and put some data in there....
October 22, 2003 at 8:31 am
You certainly could do more log backup and right after the log backup finish, copy the file to the standby server and issue restore command with no_recovery. All of...
October 22, 2003 at 8:18 am
I haven't read any article, but here is how I set it up.
1. verify that domain\account exist as an email box.
2. verify that sql-agent service account has access to that...
October 22, 2003 at 8:07 am
How about open your stored procedure up and look for the code that start with insert ....
look at the table difinition to see what what type of data and how...
October 20, 2003 at 4:43 pm
Because of time constraint and the number of record in each table, you could also copy the table over to the server that you want to grind. I was...
October 20, 2003 at 9:54 am
If upgrate wizard doesn't work why don't do you import/export wizard? Last year I've done hundreds of 6.5 upgrade and I didn't have use upgrade wizard because it was...
October 20, 2003 at 9:17 am
Just a though, Why would we use maintenance plan? How do we know if 1 or all of the backup job failed? If you were to set...
October 20, 2003 at 9:02 am
SQL Server does not require you to take the server offline for backup. You can back it up anytime. However it will slow down user process if there...
October 20, 2003 at 8:58 am
The advantage that I found is just using select and insert sql statement to move data between local and link server is faster then DTS. DTS has more chance...
October 17, 2003 at 1:37 pm
Viewing 15 posts - 316 through 330 (of 346 total)