Viewing 15 posts - 16 through 30 (of 340 total)
You can take only Full backups of master database..but you can take differential backups of model and msdb databases..FYI
July 6, 2008 at 2:23 am
Please refer this thread. As mentioned by Bala it is by design..
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1779257&SiteID=1
July 5, 2008 at 6:12 pm
Does the login which you use for performing this operation, exist in the destination server ?
July 1, 2008 at 2:19 am
[font="Tahoma"]If you have the most recent full backup of BudgetDb database you can restore it and retrieve the datas..[/font]
July 1, 2008 at 2:17 am
Can you try to completely uninstall using the windows installer clean up tool as shown here,
June 30, 2008 at 11:15 pm
Wonderful Phil 🙂 Adding to that also apply the latest service pack i.e SP2 for Sql Server 2005.
June 27, 2008 at 7:11 am
Hello Ola,
Sometime back when I tried to restore msdb from developer edition to enterprise edition and the error message was that edition was not supported.
June 23, 2008 at 7:02 pm
AFAIK..when you try to install it 2nd time (assuming that 1st time it was successfull) the option to select the components will be greyed out and hence you will not...
June 19, 2008 at 10:49 pm
[font="Verdana"]You can import the dts package under the legacy node and from then on you can schedule it using dtsrun utility. Have a look at this http://msdn.microsoft.com/en-us/library/aa224467(SQL.80).aspx
[/font]
June 17, 2008 at 7:17 am
You can make use of sp_help_revlogin procedure to perform that,http://support.microsoft.com/kb/246133
June 17, 2008 at 2:00 am
You can refer this document which explains about mirroring. But you cannot backup the mirror server as it would be in restoring state.
http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx
June 17, 2008 at 1:58 am
I think you can run them using dtsrun command. Refer,
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=184010&SiteID=1
June 16, 2008 at 8:37 am
Have you applied Sql Server 2005 SP2 for both the client tools as well as database engine ? If you have'nt please apply the same.
June 16, 2008 at 6:07 am
If nobody is able to connect to Sql Server 2005 try connecting using the \DAC (Dedicated admin connection) and see what process is currently running. You can query the sys.dm_exec_sessions...
June 16, 2008 at 6:02 am
I prefer Microsoft pressbooks which will be very easy to understand. If you are a beginner start with Virtual labs,
http://deepakrangarajan.blogspot.com/2008/02/links-for-sql-server-beginners.html
June 16, 2008 at 5:52 am
Viewing 15 posts - 16 through 30 (of 340 total)