Viewing 15 posts - 481 through 495 (of 860 total)
Maxer (3/25/2009)
Instead of being set for X days until it removes backups, it was X-5 days.
So backups are not...
March 25, 2009 at 5:42 pm
Cynthia DuBose (3/25/2009)
March 25, 2009 at 5:39 pm
I Hope you are trying to restore on your local server. You dont have to create database on your local server just specify it when you are restoring it.
Try using...
March 25, 2009 at 5:37 pm
As suggested you can either change the recovery model to Simple and shrink or you can backup the logs and shrink it.
March 25, 2009 at 3:19 pm
Mike John (3/25/2009)
March 25, 2009 at 3:16 pm
You can't copy it unless your server is shut down, if it is a production system, the easiest method is to copy the backup file and restore it on your...
March 25, 2009 at 2:59 pm
TRACEY (3/25/2009)
80 = 2000 and 90 = 2005Anyone got an explanation of why you should convert the database to 2005 and not leave as 2000.
AS Lynn explained that's true. same...
March 25, 2009 at 2:35 pm
GilaMonster (3/25/2009)
umar iqbal (3/25/2009)
we alredy know command is "Alter Login "Not on SQL 2000 it wouldn't have been.
Krishna (3/25/2009)
Enable Defualt trace and ...SQL 2000 forum.
oooooopssss.....:-P...
March 25, 2009 at 1:53 pm
J.K (3/25/2009)
Last day we had got a problem with my database.The passwords of our live application got resetted.And now i just want to check which all queries i...
March 25, 2009 at 1:04 pm
umar iqbal (3/25/2009)
weired. why you want to restore tempdb. was you put critical user data in it???
Umar, he wants to restore a database to tempdb.
Why you want to...
March 25, 2009 at 11:59 am
barunpathak (3/25/2009)
What is the easiest way to see if any process is...
March 25, 2009 at 10:36 am
vidhya_kumar (3/20/2009)
We have a SQL Server 2005 reporting environment, which is having performance bottlenecks with CPU utilization and memory.
As suggested would start first tuning the queries. Identify the top...
March 23, 2009 at 8:04 pm
balbirsinghsodhi (3/23/2009)
March 23, 2009 at 7:45 pm
OCS (3/23/2009)
1. Backup a sql2000 database on server1 directly into a sql2005 database on server2.
Sorry, what did you mean by this?
March 23, 2009 at 7:07 pm
Tim Walker (3/23/2009)
GilaMonster (3/19/2009)
Krishna (3/19/2009)
GilaMonster (3/19/2009)
My criteria for clustered indexes - narrow, unchanging, unique, ever-increasing.That's a good one Gail. Explains everything just in 4 words.:-D
March 23, 2009 at 5:04 pm
Viewing 15 posts - 481 through 495 (of 860 total)