Viewing 15 posts - 1 through 15 (of 1,165 total)
If you restore 7 am log with STOP AT option you may loose the other transactions which you may no need to rollback or loose them...
It depends on the what...
January 5, 2010 at 2:19 pm
Make sure you Stop the SQL Server Agent service before connecting to an instance of SQL Server in single-user mode; otherwise, the SQL Server Agent service uses the connection, thereby...
January 5, 2010 at 1:49 pm
If you have another msdb backup from different server with same build can be restored but you loose all the history or jobs etc...
http://sqlblog.com/blogs/tibor_karaszi/archive/2008/08/27/rebuilding-msdb-on-sql-server-2008.aspx
January 5, 2010 at 1:38 pm
January 5, 2010 at 1:16 pm
Migrating SQL Server 2000 to SQL Server 2008
Free tool for moving SQL Server logins: Idera SQL permissions
January 5, 2010 at 1:15 pm
Try copy and paste the following and restart it...
-m;-dM:\Program Files\Microsoft SQL Server\MSSQL10.INST4\MSSQL\DATA\master.mdf;-eM:\Program Files\Microsoft SQL Server\MSSQL10.INST4\MSSQL\Log\ERRORLOG;-lM:\Program Files\Microsoft SQL Server\MSSQL10.INST4\MSSQL\DATA\mastlog.ldf
Under what account sql server is running?
January 5, 2010 at 1:03 pm
Can you post the startup parameter string and what edition of sql server it is?
January 5, 2010 at 12:48 pm
You can use UNC path but if you want to troubleshoot there will be many factors...always better local and then copy but if you don't have the space locally then...
January 5, 2010 at 12:39 pm
Make sure the sql instance is not running and the log folder path exists and you login account has the sufficient access.
Make sure SQL Agent is disabled....
Have tried using SQL...
January 5, 2010 at 12:13 pm
It is advisable to upgrade to sql 2005 instead of sql 2000 again to different edition as previous poster mentioned...
but it is your call and requirement...
Here is the link which...
July 17, 2008 at 11:49 pm
Is SQL agent sevice account has the access to sql and has right password?
Looks to be it is access/permissions issue.
June 18, 2008 at 1:54 pm
May be something might have corrupted during ssms installation...
Try to remove and resinstall SQL tools or re-apply service pack...
June 18, 2008 at 1:51 pm
Yes...SSMS is slow there are many complains about it...
They improved in SP2, try to apply SP2 and see if it improve any better along with more memory to your Laptop...
June 18, 2008 at 1:46 pm
There is no option in sql server to backup the single table using backup command...but you can use DTS or BCP to copy the data and generate the table script...
June 12, 2008 at 12:58 pm
1. Read BOL.
2. Read article available on this site and on different sites like sql-server-performance.com and microsoft.com/sql etc...
Reads the books like inside sql server and sql internals etc...
June 12, 2008 at 12:56 pm
Viewing 15 posts - 1 through 15 (of 1,165 total)