full server backup

is that possible to make a full server backup which include all databases in
the current server , DTS packages and everything else in one single backup
file?

No. The backup restore mechanism works at database level, not server level.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/


"Oren101" <Oren101@discussions.microsoft.com> wrote in message
news:AAA53155-0EED-47FA-8CCD- 08BF0DF3A3E9@microso
ft.com...
is that possible to make a full server backup which include all databases in
the current server , DTS packages and everything else in one single backup
file?

Hi,Vyas
He can use undocumented  stored procedure to do that


EXEC sp_MSforeachdb
'IF N''?'' NOT IN(''model'' ,''tempdb'', ''distribution'', ''Northwind'',
''pubs'')
BEGIN
DECLARE @sql varchar(1000);
set @sql = ''BACKUP DATABASE '' + (''?'') + '' TO DISK =
 ''''D:\MSSQL2000\MSS
QL\BACKUP'' + (''?'') + ''.bak'''' WITH INIT''
EXEC (@sql)
END'

BTW. What is about .NET examples on your site that you have promised us some
time ago :-)



"Narayana Vyas Kondreddi" <answer_me@hotmail.com> wrote in message
news:ubAFNs2kFHA.2472@TK2MSFTNGP15.phx.gbl...
> No. The backup restore mechanism works at database level, not server
> level.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/
>
>
> "Oren101" <Oren101@discussions.microsoft.com> wrote in message
> news:AAA53155-0EED-47FA-8CCD- 08BF0DF3A3E9@microso
ft.com...
> is that possible to make a full server backup which include all databases
> in
> the current server , DTS packages and everything else in one single backup
> file?
>
>

Uri, your script is still creating multiple backup files, which is not what
the OP wanted. Anyway, you could still write multiple database backups to a
single backup file though.

Anyway, I just wanted to point out that you cannot run a single command, and
create a single backup with everything that is there on the server.

Regarding the .Net code samples, hopefully before end of this year :-)
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/


"Uri Dimant" <urid@iscar.co.il> wrote in message
news:uqh7DY3kFHA.3256@TK2MSFTNGP12.phx.gbl...
Hi,Vyas
He can use undocumented  stored procedure to do that


EXEC sp_MSforeachdb
'IF N''?'' NOT IN(''model'' ,''tempdb'', ''distribution'', ''Northwind'',
''pubs'')
BEGIN
DECLARE @sql varchar(1000);
set @sql = ''BACKUP DATABASE '' + (''?'') + '' TO DISK =
 ''''D:\MSSQL2000\MSS
QL\BACKUP'' + (''?'') + ''.bak'''' WITH INIT''
EXEC (@sql)
END'

BTW. What is about .NET examples on your site that you have promised us some
time ago :-)



"Narayana Vyas Kondreddi" <answer_me@hotmail.com> wrote in message
news:ubAFNs2kFHA.2472@TK2MSFTNGP15.phx.gbl...
> No. The backup restore mechanism works at database level, not server
> level.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/
>
>
> "Oren101" <Oren101@discussions.microsoft.com> wrote in message
> news:AAA53155-0EED-47FA-8CCD- 08BF0DF3A3E9@microso
ft.com...
> is that possible to make a full server backup which include all databases
> in
> the current server , DTS packages and everything else in one single backup
> file?
>
>

is that code will backup the DTS packeges too?

Regards.
OreN101

"Uri Dimant" wrote:

> Hi,Vyas
> He can use undocumented  stored procedure to do that
>
>
> EXEC sp_MSforeachdb
> 'IF N''?'' NOT IN(''model'' ,''tempdb'', ''distribution'', ''Northwind'',
> ''pubs'')
>     BEGIN
>  DECLARE @sql varchar(1000);
>  set @sql = ''BACKUP DATABASE '' + (''?'') + '' TO DISK =
>  ''''D:\MSSQL2000\MSS
QL\BACKUP'' + (''?'') + ''.bak'''' WITH INIT''
>  EXEC (@sql)
>  END'
>
> BTW. What is about .NET examples on your site that you have promised us so
me
> time ago :-)
>
>
>
> "Narayana Vyas Kondreddi" <answer_me@hotmail.com> wrote in message
> news:ubAFNs2kFHA.2472@TK2MSFTNGP15.phx.gbl... 
>
>
>

Yes, if your DTS packages are stored in SQL Server.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/


"Oren101" <Oren101@discussions.microsoft.com> wrote in message
news:0937D676-861F-4FFB-9174- 156131BFC4E8@microso
ft.com...
is that code will backup the DTS packeges too?

Regards.
OreN101

"Uri Dimant" wrote:

> Hi,Vyas
> He can use undocumented  stored procedure to do that
>
>
> EXEC sp_MSforeachdb
> 'IF N''?'' NOT IN(''model'' ,''tempdb'', ''distribution'', ''Northwind'',
> ''pubs'')
>     BEGIN
>  DECLARE @sql varchar(1000);
>  set @sql = ''BACKUP DATABASE '' + (''?'') + '' TO DISK =
>  ''''D:\MSSQL2000\MSS
QL\BACKUP'' + (''?'') + ''.bak'''' WITH INIT''
>  EXEC (@sql)
>  END'
>
> BTW. What is about .NET examples on your site that you have promised us
some
> time ago :-)
>
>
>
> "Narayana Vyas Kondreddi" <answer_me@hotmail.com> wrote in message
> news:ubAFNs2kFHA.2472@TK2MSFTNGP15.phx.gbl... 
 databases[color=dark
red] 
 backup[color=darkred
] 
>
>
>

how come? the script above make backups to the databases in the sql server
instance ,not to any other objects(like DTS)?

"Oren101" wrote:

> is that code will backup the DTS packeges too?
>
> Regards.
> OreN101
>
> "Uri Dimant" wrote:
> 

I agree - how does this grab the DTS packages?  The DTS packages are
saved to the server - not to a database.  The backup command only
references a specific database.

If you save DTS packages to SQL Server, then they get stored in the msdb
database.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/


<unc27932@yahoo.com> wrote in message
news:1122560371.634115.202710@z14g2000cwz.googlegroups.com...
I agree - how does this grab the DTS packages?  The DTS packages are
saved to the server - not to a database.  The backup command only
references a specific database.

Well, now there's something I didn't realize.  These newsgroups are
helpful aren't they. :)