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
[font="Verdana"]- Deepak[/font]
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
[font="Verdana"]- Deepak[/font]
July 5, 2008 at 6:12 pm
Does the login which you use for performing this operation, exist in the destination server ?
[font="Verdana"]- Deepak[/font]
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]
[font="Verdana"]- Deepak[/font]
July 1, 2008 at 2:17 am
Can you try to completely uninstall using the windows installer clean up tool as shown here,
http://support.microsoft.com/kb/290301/
[font="Verdana"]- Deepak[/font]
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.
[font="Verdana"]- Deepak[/font]
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.
[font="Verdana"]- Deepak[/font]
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...
[font="Verdana"]- Deepak[/font]
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]
[font="Verdana"]- Deepak[/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
[font="Verdana"]- Deepak[/font]
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
[font="Verdana"]- Deepak[/font]
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
[font="Verdana"]- Deepak[/font]
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.
[font="Verdana"]- Deepak[/font]
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...
[font="Verdana"]- Deepak[/font]
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
[font="Verdana"]- Deepak[/font]
June 16, 2008 at 5:52 am
Viewing 15 posts - 16 through 30 (of 340 total)