Viewing 15 posts - 121 through 135 (of 859 total)
sumanta.roy52 (5/11/2009)
I am trying to create databse snapshots in my database through T-SQL. But it showing as 'Database Snapshot is not supported on Standard Edition'. But SQL server managemant...
May 11, 2009 at 6:20 am
More info on this please?
On what physical disks have yuo got them?
Yes seperation them to 2 different physical disks does improve performance . Ideally you should be keep them...
May 11, 2009 at 6:18 am
k.omprakash26 (5/3/2009)
is there a way we can restore a single table from the backup?
i heard lightspeed enterprise version supports object level recovery but not sure if it handles all...
May 10, 2009 at 12:43 pm
jai_sl2000 (5/5/2009)
Hi All,Is it possible restore database SQL 2008 backup to SQL 2005?. I try to restore sql2008 backup to SQL 2005 server, but it failed.
AS others have suggested u...
May 10, 2009 at 12:41 pm
san (5/7/2009)
i have a question that can i take tempdb backup?my server is on it never stop////
so can i take that backup?
No, but why did u want to though? There's...
May 10, 2009 at 12:39 pm
nadellapradeep (5/7/2009)
Iam New to SQL Server Database Administration. For implementing Backup&Restore We have choosen Full Recovery Model. but all of sudden the recovery model was switched from Full Recovery...
May 10, 2009 at 12:33 pm
Wait!!! but you are saying you are trying to backup the database? then why is it running DBCC?
May 10, 2009 at 5:08 am
mssqlsvr (5/9/2009)
I am new sql server Can any explain what kind of data in the mdf, ldf files in the sql server.Thanks & Regards,
Sathish.
These are created when you create the...
May 10, 2009 at 4:51 am
Look through creating Triggers, if you want to keep track of DDL and some DML changes then Defualt trace would be handy.
After looking at these if you still need...
May 10, 2009 at 3:35 am
I have seen, you tried much to get out of this issue.
Check out your maintenance task that is running every night. Put more focus on your backup databases job and...
May 10, 2009 at 3:14 am
prasadrandi (5/9/2009)
Hi all,How can i migrate the roles form Sql server 2000 to 2005?
Ramaprasad.
Script out the logins and execute them against your 2005.
Check this out which is handy:
May 10, 2009 at 2:48 am
prasadrandi (5/9/2009)
hi,I am trying to move Master database from the 2000 to 2005.
without stop the production server is it possible or not?
if possible give me some guidance
Ramaprasad.
But why want to...
May 10, 2009 at 2:44 am
Robert Davis (5/8/2009)
Krishna Potlakayala (4/18/2009)
Sam Shiell (4/18/2009)
we don't need a full-time dba".OWssssss... You are going to hurt your SQL servers, which is your data, which is your business.:-D
I...
May 9, 2009 at 3:36 am
Do you have any jobs running at the same time at 3 AM? Or is these any delay with any job like rebuilding indexes or any operation that takes exclusive...
May 7, 2009 at 6:15 am
Are you sure that you are on SQL 2005? Are you trying to change this in SQL 2000 by any chance?
May 7, 2009 at 6:11 am
Viewing 15 posts - 121 through 135 (of 859 total)