Viewing 15 posts - 28,606 through 28,620 (of 39,771 total)
Please let us know what the search specifically is along with the table that is giving you issues.
A 5000 row table can give you issues and a 50billion row table...
May 9, 2008 at 7:43 pm
I have checked sys.databases for the list of databases and then looked for backup files in the file system. That way I can be sure the backup occurred and also...
May 9, 2008 at 10:30 am
There should be more details in a text file. Check the maintenance plans for logging and the location.
May 9, 2008 at 10:28 am
My guess is that certain server level permissions cannot be trasnferred this way. Perhaps this explains it?
http://support.microsoft.com/kb/913422
Is this a user and not a login?
May 9, 2008 at 10:26 am
you have to do what Greg suggested.
May 9, 2008 at 9:40 am
It depends on whether or not the data in the filegroup changed and how that affects the rest of the database. It's possible to restore the file and cause issues...
May 9, 2008 at 9:39 am
If you run a transaction log backup, the inactive portion is truncated and reused. Maintenance plan or not.
May 9, 2008 at 9:37 am
Good advice above from Tom.
I think backups and security are most important, but it's good to get the other information listed above.
May 9, 2008 at 9:19 am
Or the server is down. This can be a network or permissions error.
May 9, 2008 at 9:18 am
Follow Matt's advice. Dont' delete anything.
Can you connect with iqsl and do a dbcc opentran in tempdb?
May 9, 2008 at 9:17 am
If you have queries with lots of static information, you can replicate to other instances on other servers and potentialy gain some performance, but your application has to support this.
You...
May 9, 2008 at 9:16 am
I'd follow the advice above, especially Robert's, but understand that you can only get back to the MDF file. You can't remove that one since it has system information in...
May 9, 2008 at 9:14 am
You are welcome and let me tell you that I learn from many of you still. I appreciate you coming, more than just because it pays the bills. I enjoy...
May 9, 2008 at 9:12 am
That's strange. I wonder what it's doing as well. Profiler help at all or does it just show xp_sqlmaint?
May 9, 2008 at 9:09 am
Viewing 15 posts - 28,606 through 28,620 (of 39,771 total)