Random number in Database backup from SQL Server 2

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

Random number in Database backup from SQL Server 2

Author

Topic

Duke11
Starting Member

1 Post

Posted - 2011-06-10 : 05:34:38

Hi everyone,

when i run a database backup full or differential on SQL Server 2008 or R2, i always get DatabaseName_backup_2011_06_09_214502_5831448.bak . Is there any option to not generate last random number in the name of database backup "_5831448"? I don't have any random number in SQL Server 2005.

Thanks in advance

Pete

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-06-10 : 12:48:53

How are you performing the backups?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

jeffw8713
Aged Yak Warrior

819 Posts

Posted - 2011-06-10 : 16:36:37

No, there is no way to modify how the file name is generated when using the maintenance plan task. If you want to get rid of it, create your own script to backup the databases.

If you like using the maintenance plans and don't want to create separate agent jobs and/or steps for your backups, you can always use the Execute SQL Task in the maintenance plan to call out to your own script.

Jeff

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2011-06-10 : 17:13:14

I have to ask, why is it a problem?

Also, the number is not really random; it's just the last part of the time component.

SELECT dt = SYSDATETIME()

Result:

dt                          
--------------------------- 
2011-06-10 17:11:55.4355039

CODO ERGO SUM

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources